/*
 Navicat Premium Dump SQL

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44)
 Source Host           : 127.0.0.1:3306
 Source Schema         : smart_community

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44)
 File Encoding         : 65001

 Date: 27/08/2025 10:51:44
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sc_repair_progress
-- ----------------------------
DROP TABLE IF EXISTS `sc_repair_progress`;
CREATE TABLE `sc_repair_progress` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '进度ID',
  `order_id` bigint(20) NOT NULL COMMENT '工单ID',
  `order_no` varchar(50) NOT NULL COMMENT '工单号',
  `progress_type` tinyint(4) NOT NULL COMMENT '进度类型：1-受理，2-分配，3-开始维修，4-完成，5-取消',
  `progress_title` varchar(100) DEFAULT NULL COMMENT '进度标题',
  `progress_content` text COMMENT '进度内容',
  `progress_time` datetime DEFAULT NULL COMMENT '进度发生时间',
  `operator_id` bigint(20) DEFAULT NULL COMMENT '操作人ID',
  `repairman_id` bigint(20) DEFAULT NULL COMMENT '维修人员ID',
  `repairman_name` varchar(50) DEFAULT NULL COMMENT '维修人员姓名',
  `remark` text COMMENT '备注信息',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态：1-正常，0-已删除',
  `sort_order` int(11) DEFAULT '0' COMMENT '排序字段',
  `operator_name` varchar(50) DEFAULT NULL COMMENT '操作人姓名',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_order_id` (`order_id`),
  KEY `idx_order_no` (`order_no`),
  KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COMMENT='维修工单进度记录表';

-- ----------------------------
-- Records of sc_repair_progress
-- ----------------------------
BEGIN;
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (1, 4, 'RO20250714150146334859', 2, NULL, '工单已受理', '2025-07-16 11:39:12', 1, NULL, NULL, NULL, 1, 0, '系统', '2025-07-16 11:39:12');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (2, 4, 'RO20250714150146334859', 3, NULL, '开始维修', '2025-07-16 11:39:25', 24, NULL, NULL, NULL, 1, 0, '系统', '2025-07-16 11:39:25');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (3, 3, 'RO202501003', 2, NULL, '工单已受理', '2025-07-17 03:01:39', 6, NULL, NULL, NULL, 1, 0, '系统', '2025-07-17 03:01:39');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (4, 3, 'RO202501003', 3, NULL, '开始维修', '2025-07-17 03:10:09', 24, NULL, NULL, NULL, 1, 0, '系统', '2025-07-17 03:10:09');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (6, 2, 'RO202501002', 2, '工单受理', '工单已受理，分配维修师傅：维修人员', '2025-07-17 12:16:14', 1, 1, '维修人员', NULL, 1, 2, '系统用户', '2025-07-17 12:16:14');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (8, 2, 'RO202501002', 3, '开始维修', '开始维修', '2025-07-17 12:16:37', 1, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 12:16:37');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (10, 2, 'RO202501002', 4, '维修完成', '工单已完成，备注：维修结果：搞不定问题，我就搞定发出问题的人，业主已被我解决！', '2025-07-17 12:17:35', 1, NULL, NULL, NULL, 1, 6, '系统用户', '2025-07-17 12:17:35');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (12, 1, 'RO202501001', 5, '工单取消', '工单已取消，备注：取消原因：用户取消', '2025-07-17 12:17:59', 1, NULL, NULL, NULL, 1, 2, '系统用户', '2025-07-17 12:17:59');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (13, 5, 'RO20250717122104866840', 1, '工单创建', '工单已创建，等待受理', '2025-07-17 12:21:04', 1, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-17 12:21:04');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (15, 5, 'RO20250717122104866840', 2, '工单受理', '工单已受理，分配维修师傅：维修人员', '2025-07-17 12:21:21', 1, 1, '维修人员', NULL, 1, 3, '系统用户', '2025-07-17 12:21:21');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (17, 5, 'RO20250717122104866840', 3, '开始维修', '开始维修', '2025-07-17 12:21:23', 1, NULL, NULL, NULL, 1, 5, '系统用户', '2025-07-17 12:21:23');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (19, 5, 'RO20250717122104866840', 4, '维修完成', '工单已完成，备注：维修结果：修理完毕，重新换了个新空调！', '2025-07-17 12:29:39', 1, NULL, NULL, NULL, 1, 5, '系统用户', '2025-07-17 12:29:39');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (20, 6, 'RO20250717123041492791', 1, '工单创建', '工单已创建，等待受理', '2025-07-17 12:30:42', 1, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-17 12:30:42');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (22, 6, 'RO20250717123041492791', 2, '工单受理', '工单已受理，分配维修师傅：维修人员', '2025-07-17 12:31:04', 1, 1, '维修人员', NULL, 1, 3, '系统用户', '2025-07-17 12:31:04');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (24, 6, 'RO20250717123041492791', 3, '开始维修', '开始维修', '2025-07-17 13:14:28', 1, NULL, NULL, NULL, 1, 5, '系统用户', '2025-07-17 13:14:28');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (26, 6, 'RO20250717123041492791', 4, '维修完成', '工单已完成，备注：维修结果：RO20250717123041492791 ok', '2025-07-17 13:14:57', 1, NULL, NULL, NULL, 1, 7, '系统用户', '2025-07-17 13:14:57');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (28, 3, 'RO202501003', 4, '维修完成', '工单已完成，备注：维修结果：RO202501003', '2025-07-17 13:16:22', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 13:16:22');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (29, 7, 'RO20250717131734531849', 1, '工单创建', '工单已创建，等待受理', '2025-07-17 13:17:35', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-17 13:17:35');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (31, 7, 'RO20250717131734531849', 2, '工单受理', '工单已受理，分配维修师傅：测试用户2-已编辑', '2025-07-17 13:17:47', 9, 6, '测试用户2-已编辑', NULL, 1, 3, '系统用户', '2025-07-17 13:17:47');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (33, 7, 'RO20250717131734531849', 3, '开始维修', '开始维修', '2025-07-17 13:18:13', 9, NULL, NULL, NULL, 1, 5, '系统用户', '2025-07-17 13:18:13');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (35, 7, 'RO20250717131734531849', 4, '维修完成', '工单已完成，备注：维修结果：RO20250717131734531849', '2025-07-17 13:18:24', 9, NULL, NULL, NULL, 1, 7, '系统用户', '2025-07-17 13:18:24');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (37, 4, 'RO20250714150146334859', 4, '维修完成', '工单已完成，备注：维修结果：RO20250714150146334859', '2025-07-17 13:25:17', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 13:25:17');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (38, 8, 'RO20250717133859258057', 1, '工单创建', '工单已创建，等待受理', '2025-07-17 13:38:59', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-17 13:38:59');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (40, 8, 'RO20250717133859258057', 2, '工单受理', '工单已受理，分配维修师傅：测试用户3-已编辑', '2025-07-17 13:39:23', 9, 7, '测试用户3-已编辑', NULL, 1, 3, '系统用户', '2025-07-17 13:39:23');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (41, 8, 'RO20250717133859258057', 2, '分配备注', '18329188884', '2025-07-17 13:39:24', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 13:39:24');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (42, 8, 'RO20250717133859258057', 2, '状态更新', '工单状态已更新，备注：18329188884', '2025-07-17 13:39:24', 9, NULL, NULL, NULL, 1, 5, '系统用户', '2025-07-17 13:39:24');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (44, 8, 'RO20250717133859258057', 3, '开始维修', '开始维修', '2025-07-17 13:40:59', 9, NULL, NULL, NULL, 1, 7, '系统用户', '2025-07-17 13:40:59');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (46, 8, 'RO20250717133859258057', 4, '维修完成', '工单已完成', '2025-07-17 13:43:22', 9, 7, '测试用户3-已编辑', NULL, 1, 9, '系统用户', '2025-07-17 13:43:22');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (47, 8, 'RO20250717133859258057', 4, '维修完成', '工单已完成，备注：维修结果：已经维修完成！电梯可以正常运行了！；备注：已经维修完成', '2025-07-17 13:43:22', 9, NULL, NULL, NULL, 1, 10, '系统用户', '2025-07-17 13:43:22');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (48, 9, 'RO20250717135629403071', 1, '工单创建', '工单已创建，等待受理', '2025-07-17 13:56:30', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-17 13:56:30');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (50, 9, 'RO20250717135629403071', 2, '工单受理', '工单已受理，分配维修师傅：智慧物业管理员，备注：电梯坏了', '2025-07-17 13:56:41', 9, 9, '智慧物业管理员', NULL, 1, 3, '系统用户', '2025-07-17 13:56:41');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (51, 9, 'RO20250717135629403071', 2, '状态更新', '工单状态已更新，备注：电梯坏了', '2025-07-17 13:56:41', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 13:56:41');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (52, 9, 'RO20250717135629403071', 3, '开始维修', '开始维修', '2025-07-17 14:01:08', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 14:01:08');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (53, 9, 'RO20250717135629403071', 4, '维修完成', '工单已完成，维修结果：-- ========================================\n-- 删除维修工单触发器SQL脚本\n-- 作者: Wu.Liang\n-- 日期: 2025-01-30\n-- 说明: 删除维修工单相关的数据库触发器，避免重复创建进度记录\n-- ========================================\n\n-- 1. 删除维修工单状态变更触发器\nDROP TRIGGER IF EXISTS `tr_repair_order_status_change`;\n\n-- 2. 删除维修工单创建进度触发器（如果存在）\nDROP TRIGGER IF EXISTS `tr_repair_order_create_progress`;\n\n-- 3. 验证触发器已删除\nSELECT \n    TRIGGER_NAME,\n    EVENT_MANIPULATION,\n    EVENT_OBJECT_TABLE\nFROM information_schema.TRIGGERS \nWHERE EVENT_OBJECT_SCHEMA = DATABASE() \nA，备注：-- ========================================\n-- 删除维修工单触发器SQL脚本\n-- 作者: Wu.Liang\n-- 日期: 2025-01-30\n-- 说明: 删除维修工单相关的数据库触发器，避免重复创建进度记录\n-- ========================================\n\n-- 1. 删除维修工单状态变更触发器\nDROP ', '2025-07-17 14:01:20', 9, 9, '智慧物业管理员', NULL, 1, 5, '系统用户', '2025-07-17 14:01:20');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (54, 10, 'RO20250728114013143934', 1, '工单创建', '工单已创建，等待受理', '2025-07-28 11:40:14', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-28 11:40:14');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (55, 10, 'RO20250728114013143934', 2, '工单受理', '工单已受理，分配维修师傅：gufeiya4，备注：水电维修', '2025-07-28 11:40:48', 9, 30, 'gufeiya4', NULL, 1, 2, '系统用户', '2025-07-28 11:40:48');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (56, 10, 'RO20250728114013143934', 2, '状态更新', '工单状态已更新，备注：水电维修', '2025-07-28 11:40:48', 9, NULL, NULL, NULL, 1, 3, '系统用户', '2025-07-28 11:40:48');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (57, 10, 'RO20250728114013143934', 3, '开始维修', '开始维修', '2025-07-28 11:45:36', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-28 11:45:36');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (58, 11, 'RO20250808150906755493', 1, '工单创建', '工单已创建，等待受理', '2025-08-08 15:09:06', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-08-08 15:09:07');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (59, 12, 'RO20250811171820713731', 1, '工单创建', '工单已创建，等待受理', '2025-08-11 17:18:21', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-08-11 17:18:21');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (60, 13, 'RO20250811180332592308', 1, '工单创建', '工单已创建，等待受理', '2025-08-11 18:03:32', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-08-11 18:03:32');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (61, 14, 'RO20250812135933299141', 1, '工单创建', '工单已创建，等待受理', '2025-08-12 13:59:33', 32, NULL, NULL, NULL, 1, 1, '系统用户', '2025-08-12 13:59:33');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (62, 14, 'RO20250812135933299141', 2, '工单受理', '工单已受理，分配维修师傅：小呱呱', '2025-08-12 14:00:30', 32, 32, '小呱呱', NULL, 1, 2, '系统用户', '2025-08-12 14:00:30');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
